# 要避免 SQL 注入，你绝对不能在 SQL 字符串中用引号包裹 %s 占位符。
# 占位符是安装顺序来的

test = """
    SELECT
	tp.id as pid,
	tp.name as pname,
	tp.description as description,
	tb.id as bid,
	tb.name bname,
	tb.read_count bread_count
    FROM
    	t_bookinfo tb
    left join t_peopleinfo tp 
    on tb.id = tp.book_id
    where tp.id = %s
    """

test2 = """
    SELECT
	# tp.id as pid,
	# tp.name as pname,
	# tp.description as description,
	tb.id as bid,
	tb.name bname,
	tb.read_count bread_count
    FROM
    	t_bookinfo tb
    # left join t_peopleinfo tp 
    # on tb.id = tp.book_id
    where tb.id = %s
    """

tableName = "t_bookinfo"